1. Open your .csv file in Microsoft® Excel®.
2. In each cell in which you entered dates, add hour data to representthe native time zone. For example, if the date is June 9, 2011 andthe time zone is GMT+8, enter June 9, 2011 8:00. Excel will reformat this to 6/9/2011 8:00.
3. Right-click the cell in which you entered dates, and click Format Cells.
4. Click Number | Custom.
5. In Type, enter yyyy-mm-ddThh:mm:ss.sssZ. For example, if the cell was 6/9/2011 8:00, it’s now 2011–06–09T08:00:00.00Z.